home *** CD-ROM | disk | FTP | other *** search
Text File | 1994-06-12 | 1.6 KB | 61 lines | [TEXT/HAks] |
- --------------------------------------------------------------
- CHECKBOOK BALANCING WORKSHEET
- --------------------------------------------------------------
-
- To balance your account, first update your check register.
-
- * Add any interest.
-
- * Subtract any service charges.
-
- * Bring your checkbook balance up to date.
-
- * Put a check mark next to all items that match up with
- items in your bank statement, including interest and
- service charges.
-
- Transactions that don't have a check mark next to them
- are still outstanding.
-
- Replace the figures below with your own:
-
- 1. Enter the ending balance from your bank statement:
-
- EndingBalance = 2645.19
-
- 2. Add all deposits not yet credited in your bank statement:
-
- Deposits = 200.98 + 141.00 + 260.00
-
- 3. Add all outstanding checks and withdrawals:
-
- a = 13.54 + 3 + 209.59 + 335 + 3 + 124.99
- b = 17.45 + 87.02
- c = 0
- d = 0
- f = 0
-
- Outstanding = a + b + c + d + f
-
-
- Note: 'a','b','c' ... are subtotals so that many checks can
- be added up without having to put them all on the same line.
-
- If needed, make additional subtotal constants and
- include them in the formula for 'Outstanding'.
-
- 4. Press 'ENTER' to calculate your new current balance.
-
- CurrentBalance =
-
- If the above number matches the one in your checkbook,
- then your checkbook is in balance.
-
- ================================================================
-
- FORMULA
-
- CurrentBalance = (EndingBalance + Deposits) - Outstanding * $
-
- $ = fix(2,1) . . . . . . . . . . . Limit to 2 decimal places
- ----------------------------------------------------------------